package com.example.controller;

import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.net.URL;
import java.net.URLConnection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.LinkedList;
import java.util.List;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.util.Assert;
import static org.apache.poi.ss.usermodel.CellType.STRING;
import com.example.service.impl.AutoCbsServerImpl;
import sun.security.tools.keytool.Main;

public class test {


	public static void main(String[] args) throws IOException {
		AutoCbsServerImpl AutoCbsServerImpl = new AutoCbsServerImpl ();
		AutoCbsServerImpl.AnalyzeMTRExcelAR();

	}
 
/**
 * 读取某路径下所有文件名称
 * 
 * @param path
 * @return
 */
public List<String> traverseFolder(String path) {
	List<String> fileNames = new ArrayList<String>();
	File file = new File(path);
	if (file.exists()) {
		LinkedList<File> list = new LinkedList<File>();
		list.add(file);
		File[] files;
		while (!list.isEmpty()) {
			files = list.removeFirst().listFiles();
			for (File file1 : files) {
				if (file1.isDirectory()) {
				} else {
					fileNames.add(file1.getName());
				}
			}
		}
	} else {
	}
	return fileNames;
}


}

